

project_options = {
	"title": "Project Options",
	"comment": "",
	"sql_table": "project_options",
	"ajax_url": "./lookup_tables.php",
	"server_call_list": "lookup_read",
	"server_call_create": "lookup_create_item",
	"server_call_update": "lookup_update_item",
	"server_call_remove": "lookup_remove_item",
	"server_call_import": "lookup_create_item",
	"fields": [
		{
			"name": "id",
			"alias": "id",
			"comment": "",
			"nullable": false,
			"auto_increment": true,
			"primary_key": true,
			"sql_default": "NULL",
			"sql_size": "20",
			"sql_type": "BIGINT(20)",
			"default_value": null,
			"title": "id",
			"show_on_import": false,
			"show_on_grid": false,
			"show_on_editor": false,
			"readonly": false,
			"ui_group": "__MAIN__"
		},
		{
			"name": "name",
			"alias": "name",
			"comment": "",
			"nullable": false,
			"auto_increment": false,
			"primary_key": false,
			"sql_default": "NULL",
			"sql_size": "50",
			"sql_type": "VARCHAR(50)",
			"default_value": null,
			"title": "Name",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "General"
		},
		{
			"name": "show_field_types",
			"alias": "show_field_types",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"data_type": "boolean",
			"sql_default": null,
			"sql_size": "",
			"sql_type": "SMALLINT",
			"default_value": null,
			"title": "Show Field Types",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "General"
		},
		{
			"name": "author",
			"alias": "author",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"data_type": "text",
			"sql_default": null,
			"sql_size": "",
			"sql_type": "TINYINT",
			"default_value": null,
			"title": "Author",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "General"
		},
		{
			"name": "date_created",
			"alias": "date_created",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"data_type": "date",
			"sql_default": null,
			"sql_size": "",
			"sql_type": "TINYINT",
			"default_value": null,
			"title": "Date Created",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "General"
		},
		{
			"name": "last_modified_on",
			"alias": "last_modified_on",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"data_type": "text",
			"sql_default": null,
			"sql_size": "",
			"sql_type": "TINYINT",
			"default_value": null,
			"title": "Last Modified On",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "General"
		},
		{
			"name": "database_type",
			"alias": "database_type",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"data_type": "lookup",
			"sql_default": null,
			"sql_size": "20",
			"sql_type": "BIGINT(20)",
			"default_value": null,
			"title": "Database Type",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "Database",
			"foreign_key": {
				"sql_table": "database_types",
				"key": "shortname",
				"value": "name"
			}
		},
		{
			"name": "database",
			"alias": "database",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"data_type": "text",
			"sql_default": null,
			"sql_size": "50",
			"sql_type": "VARCHAR(50)",
			"default_value": null,
			"title": "Database",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "Database"
		},
		{
			"name": "database_server",
			"alias": "database_server",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"sql_default": null,
			"sql_size": "50",
			"sql_type": "VARCHAR(50)",
			"default_value": null,
			"title": "Database Server",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "Database"
		},
		{
			"name": "database_username",
			"alias": "database_username",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"sql_default": null,
			"sql_size": "50",
			"sql_type": "VARCHAR(50)",
			"default_value": null,
			"title": "Database Username",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "Database"
		},
		{
			"name": "database_password",
			"alias": "database_password",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"sql_default": null,
			"sql_size": "50",
			"sql_type": "VARCHAR(50)",
			"default_value": null,
			"title": "Database Password",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "Database"
		},
		{
			"name": "implementation_fields",
			"alias": "implementation_fields",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"data_type": "notes",
			"sql_default": null,
			"sql_size": "",
			"sql_type": "TINYINT",
			"default_value": null,
			"title": "Implementation Fields",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "Look and Feel"
		}
	],
	"ui_groups": [
		{
			"name": "__MAIN__"
		},
		{
			"name": "General"
		},
		{
			"name": "Database"
		},
		{
			"name": "Look and Feel"
		}
	],
	"links": [],
	"keys": [],
	"data": [],
	"form_code": {
		"ui_group": "General",
		"ui_alignment": "vertical",
		"ui_field_type": "text",
		"name": "project_options",
		"title": "Project Options",
		"default_value": null,
		"show_on_editor": true,
		"visible": true,
		"show_on_grid": true,
		"show_on_import": true,
		"readonly": false,
		"links": [],
		"entity_name": "project_options"
	},
	"form_report": {
		"group_by": null,
		"fields": [],
		"filter": []
	},
	"top": 230,
	"left": 510
}

database_types = {
	"title": "Database Types",
	"comment": "",
	"sql_table": "database_types",
	"ajax_url": "./lookup_tables.php",
	"server_call_list": "lookup_read",
	"server_call_create": "lookup_create_item",
	"server_call_update": "lookup_update_item",
	"server_call_remove": "lookup_remove_item",
	"server_call_import": "lookup_create_item",
	"fields": [
		{
			"name": "id",
			"alias": "id",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"sql_default": null,
			"sql_size": "20",
			"sql_type": "BIGINT(20)",
			"default_value": null,
			"title": "ID",
			"show_on_import": false,
			"show_on_grid": false,
			"show_on_editor": false,
			"readonly": false,
			"ui_group": "__MAIN__"
		},
		{
			"name": "shortname",
			"alias": "shortname",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"sql_default": null,
			"sql_size": "20",
			"sql_type": "VARCHAR(20)",
			"default_value": null,
			"title": "Short name",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "__MAIN__"
		},
		{
			"name": "name",
			"alias": "name",
			"comment": "",
			"nullable": true,
			"auto_increment": false,
			"primary_key": false,
			"sql_default": null,
			"sql_size": "50",
			"sql_type": "VARCHAR(50)",
			"default_value": null,
			"title": "name",
			"show_on_import": true,
			"show_on_grid": true,
			"show_on_editor": true,
			"readonly": false,
			"ui_group": "__MAIN__"
		}
	],
	"ui_groups": [
		{
			"name": "__MAIN__"
		}
	],
	"links": [
		{
			"sql_table": "project_options",
			"reference": {
				"title": "Project Options",
				"comment": "",
				"sql_table": "project_options",
				"ajax_url": "./lookup_tables.php",
				"server_call_list": "lookup_read",
				"server_call_create": "lookup_create_item",
				"server_call_update": "lookup_update_item",
				"server_call_remove": "lookup_remove_item",
				"server_call_import": "lookup_create_item",
				"fields": [
					{
						"name": "id",
						"alias": "id",
						"comment": "",
						"nullable": false,
						"auto_increment": true,
						"primary_key": true,
						"sql_default": "NULL",
						"sql_size": "20",
						"sql_type": "BIGINT(20)",
						"default_value": null,
						"title": "id",
						"show_on_import": false,
						"show_on_grid": false,
						"show_on_editor": false,
						"readonly": false,
						"ui_group": "__MAIN__"
					},
					{
						"name": "name",
						"alias": "name",
						"comment": "",
						"nullable": false,
						"auto_increment": false,
						"primary_key": false,
						"sql_default": "NULL",
						"sql_size": "50",
						"sql_type": "VARCHAR(50)",
						"default_value": null,
						"title": "Name",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "General"
					},
					{
						"name": "show_field_types",
						"alias": "show_field_types",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"data_type": "boolean",
						"sql_default": null,
						"sql_size": "",
						"sql_type": "SMALLINT",
						"default_value": null,
						"title": "Show Field Types",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "General"
					},
					{
						"name": "author",
						"alias": "author",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"data_type": "text",
						"sql_default": null,
						"sql_size": "",
						"sql_type": "TINYINT",
						"default_value": null,
						"title": "Author",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "General"
					},
					{
						"name": "date_created",
						"alias": "date_created",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"data_type": "date",
						"sql_default": null,
						"sql_size": "",
						"sql_type": "TINYINT",
						"default_value": null,
						"title": "Date Created",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "General"
					},
					{
						"name": "last_modified_on",
						"alias": "last_modified_on",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"data_type": "text",
						"sql_default": null,
						"sql_size": "",
						"sql_type": "TINYINT",
						"default_value": null,
						"title": "Last Modified On",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "General"
					},
					{
						"name": "database_type",
						"alias": "database_type",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"data_type": "lookup",
						"sql_default": null,
						"sql_size": "20",
						"sql_type": "BIGINT(20)",
						"default_value": null,
						"title": "Database Type",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "Database",
						"foreign_key": {
							"sql_table": "database_types",
							"key": "shortname",
							"value": "name"
						}
					},
					{
						"name": "database",
						"alias": "database",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"data_type": "text",
						"sql_default": null,
						"sql_size": "50",
						"sql_type": "VARCHAR(50)",
						"default_value": null,
						"title": "Database",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "Database"
					},
					{
						"name": "database_server",
						"alias": "database_server",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"sql_default": null,
						"sql_size": "50",
						"sql_type": "VARCHAR(50)",
						"default_value": null,
						"title": "Database Server",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "Database"
					},
					{
						"name": "database_username",
						"alias": "database_username",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"sql_default": null,
						"sql_size": "50",
						"sql_type": "VARCHAR(50)",
						"default_value": null,
						"title": "Database Username",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "Database"
					},
					{
						"name": "database_password",
						"alias": "database_password",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"sql_default": null,
						"sql_size": "50",
						"sql_type": "VARCHAR(50)",
						"default_value": null,
						"title": "Database Password",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "Database"
					},
					{
						"name": "implementation_fields",
						"alias": "implementation_fields",
						"comment": "",
						"nullable": true,
						"auto_increment": false,
						"primary_key": false,
						"data_type": "notes",
						"sql_default": null,
						"sql_size": "",
						"sql_type": "TINYINT",
						"default_value": null,
						"title": "Implementation Fields",
						"show_on_import": true,
						"show_on_grid": true,
						"show_on_editor": true,
						"readonly": false,
						"ui_group": "Look and Feel"
					}
				],
				"ui_groups": [
					{
						"name": "__MAIN__"
					},
					{
						"name": "General"
					},
					{
						"name": "Database"
					},
					{
						"name": "Look and Feel"
					}
				],
				"links": [],
				"keys": [],
				"data": [],
				"form_code": {
					"ui_group": "General",
					"ui_alignment": "vertical",
					"ui_field_type": "text",
					"name": "project_options",
					"title": "Project Options",
					"default_value": null,
					"show_on_editor": true,
					"visible": true,
					"show_on_grid": true,
					"show_on_import": true,
					"readonly": false,
					"links": [],
					"entity_name": "project_options"
				},
				"form_report": {
					"group_by": null,
					"fields": [],
					"filter": []
				},
				"top": 230,
				"left": 510
			},
			"mapping": [
				{
					"source": "shortname",
					"destination": "database_type"
				}
			]
		}
	],
	"keys": [],
	"data": [
		{
			"id": 1,
			"name": "MySQL",
			"shortname": "mysql"
		},
		{
			"id": null,
			"shortname": "sqlite",
			"name": "Sqlite",
			"null": 1
		}
	],
	"form_code": {
		"ui_group": "__MAIN__",
		"ui_alignment": "horizontal",
		"ui_field_type": "text",
		"name": "database_types",
		"title": "Database Types",
		"default_value": null,
		"show_on_editor": true,
		"visible": true,
		"show_on_grid": true,
		"show_on_import": true,
		"readonly": false,
		"links": [],
		"entity_name": "database_types"
	},
	"form_report": {
		"group_by": null,
		"fields": [],
		"filter": []
	},
	"top": 90,
	"left": 130
}
